SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Ludovic FERRE
-- Create date: 2009-09-05
-- Description:	Retrieve ALL AD
-- =============================================
CREATE PROCEDURE getAllAD
AS
BEGIN
	SET NOCOUNT ON;
	SELECT case AD_ID when '00' then '0' when '06' then '6' else AD_ID end
      FROM ASSO
END
/* exec getAllAD */
GO